Legacy Google Sheets integration

Legacy Google Sheets integration

For some specific cases where we could not bring improvements, you might have access to the legacy Google Sheets integration. The below documentation explains how the legacy version works.

The Google Drive integration allows you to send form submissions to spreadsheets. All submissions for one form will appear in the same spreadsheet.

Before integrating with Google Drive there are a few things that you should be aware of:

  • Do not delete any spreadsheet columns generated by your form fields. You can delete fields from your form but not their correspondent spreadsheet column in Google Drive.
  • Make test submissions after applying changes, to update on both sides.
  • Selecting a group of cells and sorting/filtering data will break the integration.

You’ll find the Google Drive integration in the Integrations section of your form. Add the application and hit the Connect button. You’ll be redirected to a separate page to add your Google account credentials (if not logged in).

Google Drive app

When you check your Google Drive account after submissions were made, you will see that you’ve got a new spreadsheet with the name of your form showing each submission’s input on one row. The form data is not sent immediately, but after one to five minutes.

The counter displayed next to the name of the Google account specifies the number of times a new token has been created. A new token is created each time you choose the Connect another account option within the dropdown and type in a Gmail address that you already used.

Connected accounts

Our integration works very well with event registration forms and online surveys when you need to share form entries quickly with other interested parties.

Important Notes

To change both the label names and the order of the columns in your spreadsheet, you’ll need to follow these steps:
  • 1. First, change the label names and submit your form.
  • 2. Reorder the columns in your spreadsheet and submit the form after you are done.
The first test communicates your final changes. Make two submissions to update the spreadsheet. Following these steps will prevent the integration from failing. Make sure you have at least one test submission made between step 1 and step 2.

If the integration is not working correctly, click on the Remove button and add Google Drive again. A new spreadsheet will be created. The connection with the old spreadsheet can not be restored.

Remove app

Leave a Reply

Your email address will not be published. Required fields are marked *

Frequently Asked Questions

Here is a list of the most frequently asked questions. For more FAQs, please browse through the  FAQs page.

Is this service free?
Yes, we offer a free form builder service. Just sign up to the Basic plan and you are all set. This plan is forever free, but you are limited with a few features only, such as 5 forms per account, 100 submissions per month and you have to keep the backlink to 123FormBuilder on your forms. Check out our features matrix for more information.
How many forms can I create?
It depends on the service plan you are on. Higher service plans enable more features, including more web forms for your account. If you need more forms, go to the My Account section of your account and click the upgrade button. To create an unlimited number of forms, either upgrade to the Platinum service plan or higher. Consult our features matrix for more information.
How can I publish my forms?
You can publish your forms in many ways, by using their direct URL or HTML link, embedding them with a JavaScript code, Inline HTML or iFrame, using the Facebook app or the WordPress plugin, using popups, the Blogger code snippet and many more. Once you have created and customized your form, go to the Publish section to complete your work. Read more in our documentation.
How do I change my form design?
You can change the design of your form for more information. in the Themes section, which is located in your form settings. We offer a set of more than 30 predefined form themes for your forms, but you can also create your own from scratch. You can customize the submit button, the logo and more. To apply your own stylesheets, all forms come with a custom CSS editor.

Can't find what you're looking for?